Using Date Queries

Date queries can be made using a variety of date formats and separators.

Valid Formats

Use the following date formats to execute queries in ODBC.

Date Format	Example
MonthName/Day/Year	February/14/2023
Day/MonthName/Year	14/February/2023
Year/Month/Day	2023/02/14

Valid Separators

Use the following date separators: forward slash ("/"), dash ("-"), space (" "), and colon (":"). Various separators have equivalent value, so '2023/02/14' = '2023-02-14' = '2023 02 14' = '2023:02:14'.

Example

SELECT * FROM mysite_uis.realtimevalues WHERE Time = '2023/02/14'